﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;

namespace Common
{
    public class CommonHelper
    {
        /// <summary>
        /// 将datatable转为list
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static List<T> DataTableToList<T>(DataTable dt) where T : class, new()
        {

            // 定义集合 
            List<T> ts = new List<T>();
            try
            {
                //定义一个临时变量 
                string tempName = string.Empty;
                //遍历DataTable中所有的数据行 
                foreach (DataRow dr in dt.Rows)
                {
                    T t = new T();
                    // 获得此模型的公共属性 
                    PropertyInfo[] propertys = t.GetType().GetProperties();
                    //遍历该对象的所有属性 
                    foreach (PropertyInfo pi in propertys)
                    {
                        tempName = pi.Name;//将属性名称赋值给临时变量 
                                           //检查DataTable是否包含此列（列名==对象的属性名）  
                        if (dt.Columns.Contains(tempName))
                        {
                            //取值 
                            object value = dr[tempName];
                            //如果非空，则赋给对象的属性 
                            if (value != DBNull.Value)
                            {
                                pi.SetValue(t, value, null);
                            }
                        }
                    }
                    //对象添加到泛型集合中 
                    ts.Add(t);
                }
            }
            catch (Exception ex)
            {

            }

            return ts;
        }


        //将list转为datable
        public static DataTable ConvertListToDataTable<T>(List<T> list) where T : class, new()
        {
            if (list == null || list.Count == 0)
            {
                throw new ArgumentException("List cannot be null or empty.");
            }

            DataTable dataTable = new DataTable();
            var properties = typeof(T).GetProperties();

            foreach (var property in properties)
            {
                dataTable.Columns.Add(property.Name, property.PropertyType);
            }

            foreach (var item in list)
            {
                DataRow dataRow = dataTable.NewRow();
                foreach (var property in properties)
                {
                    dataRow[property.Name] = property.GetValue(item);
                }
                dataTable.Rows.Add(dataRow);
            }

            return dataTable;
        }
    }
}
